Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-20-2024, 11:58 AM
theuser theuser is offline Maybe an array formula to transpose records? Windows 11 Maybe an array formula to transpose records? Office 2021
Novice
Maybe an array formula to transpose records?
 
Join Date: Mar 2024
Posts: 1
theuser is on a distinguished road
Default Maybe an array formula to transpose records?

I have a table of data. Note that the number of rows per index can vary and the total number of unique index values will vary and not be named TestX:



Index Concat
Test1 DataValue1
Test1 DataValue2
Test1 DataValue3
Test1 DataValue4
Test1 DataValue5
Test1 DataValue6
Test1 DataValue7
Test1 DataValue8
Test1 DataValue9
Test2 DataValue10
Test2 DataValue11
Test2 DataValue12
Test2 DataValue13
Test2 DataValue14
Test2 DataValue15
Test2 DataValue16
Test2 DataValue17
Test2 DataValue18
Test2 DataValue19
Test3 DataValue20
Test3 DataValue21
Test3 DataValue22
Test3 DataValue23
Test3 DataValue24
Test3 DataValue25
Test3 DataValue26
Test3 DataValue27
Test3 DataValue28
Test3 DataValue29


I would like to transpose the data so each index item shows the related data on one row:


Capture1 hosted at ImgBB — ImgBB

Ultimately, I would like to filter it down to unique indexes, but I can do that myself:


Capture2 hosted at ImgBB — ImgBB

My question is can I do at least the column to row (second step/picture) conversion with a formula?



Thanks for any help you can provide.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Maybe an array formula to transpose records? Concatenating in an Array formula Phil H Excel 6 02-25-2019 08:36 AM
Array formula value not available error for one result emarkona Excel 1 03-08-2018 03:00 PM
Array Formula Macacidic Excel 2 09-12-2017 08:19 AM
Maybe an array formula to transpose records? Excel simplify formula - array of sequential numbers Wries Excel Programming 1 05-12-2014 08:32 AM
Maybe an array formula to transpose records? Complex array formula andrei Excel 9 02-03-2012 03:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft