Dear All,
We are trying to transpose the below data from Vertical to Horizontal and using Cross tab but the same not working.
Can anyone advise on this please.
Data sample:
| Record ID | Unique account | Content |
| 1 | 1 | KA42C2107N3 |
| 2 | 2 | 009309159378 |
| 3 | 3 | 04/02/2020 |
| 4 | 4 | 04/02/2020 |
| 5 | 5 | 04/02/2020 |
| 6 | 6 | 09:51 |
| 7 | 7 | Data Entry |
| 8 | 8 | MOBILE INCOMING RECEIPT |
| 9 | 8 | Receipt |
| 10 | 9 | 180 |
| 11 | 10 | 2500 |
| 12 | 11 | 91-"TEXTEXTRACTED" |
| 13 | 1 | KA42C2107N36 |
| 14 | 2 | 009309159378 |
| 15 | 3 | 8/2/2020 |
| 16 | 4 | 04/02/2020 |
| 17 | 5 | 04/02/2020 |
| 18 | 6 | 09:51 |
| 19 | 7 | Data Entry |
| 20 | 8 | MOBILE INCOMING RECEIPT |
| 21 | 9 | 180 |
| 22 | 10 | 4500 |
| 23 | 11 | 91-"TEXTEXTRACTED" |
| 24 | 1 | KA42C2107N36 |
| 25 | 2 | 009309159378 |
| 26 | 3 | 8/2/2020 |
| 27 | 4 | 04/02/2020 |
| 28 | 5 | 04/02/2020 |
| 29 | 6 | 09:51 |
| 30 | 7 | Data Entry |
| 31 | 8 | MOBILE INCOMING RECEIPT |
| 32 | 9 | 180 |
| 33 | 10 | 5500 |
| 34 | 11 | 91-"TEXTEXTRACTED" |
Result should be as below:
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| KA42C2107N3 | 009309159378 | 04/02/2020 | 04/02/2020 | 04/02/2020 | 09:51 | Data Entry | MOBILE INCOMING RECEIPT, Receipt | 180 | 2500 | 91-"TEXTEXTRACTED" |
| KA42C2107N36 | 009309159378 | 8/2/2020 | 04/02/2020 | 04/02/2020 | 09:51 | Data Entry | MOBILE INCOMING RECEIPT | 180 | 4500 | 91-"TEXTEXTRACTED" |
| KA42C2107N36 | 009309159378 | 44045 | 04/02/2020 | 04/02/2020 | 09:51 | Data Entry | MOBILE INCOMING RECEIPT | 180 | 5500 | 91-"TEXTEXTRACTED" |
Thanks & Regards
Mahadev
