Vertical to Horizontal Table

[mahadevaswab]

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

[atcodedog05 · Accepted solution]

Hi @mahadevaswab 

You can start a new block on each occurrence of 1 in unique account. Later take this has ID for crosstab.

Workflow:

1. Using mult-row formula to start new block on occurecn of 1 in Unqiue account.

2. Using crosstab to convert to table row as ID, record id as name and content as value.

Hope this helps : )