Hello!

I have a data set that has an general ledger code that is vertical and an entity code that is horizontal. The table will have an amount that relates to a certain general ledger account for the certain entity. I need to create a list that goes horizontal that shows the general ledger account, the entity code and the amount in a horizontal list. I have attached an example below.

This is how the data is currently:

 Entity number  General ledger account123100$1$0$2101$4$0$1102$1$1$1

I need the data to be in list form like below:

General ledger accountEntityAmount1001$11002$01003$21011$41012$01013$11021$11022$11023$1

I have a large dataset and cannot transpose everything invididually.

Thank you!!

​Hello! I have a data set that has an general ledger code that is vertical and an entity code that is horizontal. The table will have an amount that relates to a certain general ledger account for the certain entity. I need to create a list that goes horizontal that shows the general ledger account, the entity code and the amount in a horizontal list. I have attached an example below. This is how the data is currently: Entity number  General ledger account123100$1$0$2101$4$0$1102$1$1$1 I need the data to be in list form like below:General ledger accountEntityAmount1001$11002$01003$21011$41012$01013$11021$11022$11023$1 I have a large dataset and cannot transpose everything invididually. Thank you!!  Read More

​