Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I searched the forum for this but couldn't find what I was looking for. If
the solution already exists then please point me in the right direction. The issue is that I have a table that looks like this: Period Account1 Account2 1 100 125 2 80 130 What I need to figure out is how i can transpose the data to look like this: Account Period Amt Account1 1 100 Account1 2 80 Account2 1 125 Account2 2 130 Of course the table is quite large (12 periods by 350 accounts) Is there any suggestions? Thanks in advance Leo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automating transposition exercise | Excel Worksheet Functions | |||
Complex sum | Excel Discussion (Misc queries) | |||
Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
Transposition impossibility? | Excel Discussion (Misc queries) | |||
Transposition | Excel Worksheet Functions |