Hi I have a problem regarding my data. I want to transpose the other values in the data from horizontal to vertical. See sample below:
Original Data:
22222 | 234343 | 55555 | 122222 | 33333 | 755555 | ||
UniqueNo | Description | Purchases | APV | PPE | Inventory | Small Purch | Office Eqpt |
1 | To purchase | 100 | -100 | 400 | -400 | ||
2 | To acquire | 200 | -200 | ||||
3 | To sell | 300 | -300 | 500 | -500 |
Expected Output:
UniqueNo | Description | Code | Account Name | Amount |
1 | To purchase | 22222 | Purchases | 100 |
234343 | APV | -100 | ||
55555 | PPE | 400 | ||
122222 | Inventory | -400 | ||
2 | To acquire | 22222 | Purchases | 200 |
234343 | APV | -200 | ||
3 | To sell | 33333 | Small Purch | 500 |
755555 | Office Eqpt | -500 |
Basicaly, I want to transform the data that would check the transactions per Unique No. in which adding the Account Name and Amount columns that were presented horizontally in origin. Can you help me with this one please?
hello thank you for this. How about the column "Code"?