Forum Discussion
Transposing Formula
Hello, Can someone please assist with a formula duplicating attached/below example of going from a vertical list of data to a horizontal grouping?
KC371 , It seems that you are having old version of Excel.
For my own use i had made a macro about a decade ago. See file Table RCF3.xls , sheet "concatenated".
Note : this was made for personal use only so it is not so much user friendly as it is possible to be made if needed to be given to others. But i hope it could help you for time being with immediate issue.
The complementary (opposite use) file Table FCR.xls is also attached.