Hi all, i have a similar issue that the one posted here. But this time the tile module didn't help. I also tried conditional formulas and transpose without much success. https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transposing-rows-to-columns-every-x-number-of-rows/m-p/890733#M214377 I basically have this data data_headernameJohn Doecreation date1/14/2022 10:03blood typeOtest date1/18/2022test typeblood test +evaluation date1/14/2022invoice amount49Value Date1/18/2022blood typeOnameRichy richtest date12/21/2021test typeblood testevaluation date12/20/2021creation date12/20/2021 09:23blood typeO-invoice amount10Value Date12/21/2021blood typeO- and would like to have it namecreation dateblood typetest datetest typeevaluation dateinvoice amountValue DateJohn Doe1/14/2022 10:03O1/18/2022blood test +1/14/2022491/18/2022Richie rich12/20/2021 09:23O-12/21/2021blood test12/20/20211012/21/2021

Transposing rows to columns when all the data is in one column

Hi all,

i have a similar issue that the one posted here. But this time the tile module didn't help. I also tried conditional formulas and transpose without much success.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transposing-rows-to-columns-every-x-number-of-rows/m-p/890733#M214377

I basically have this data

data_header

name

John Doe

creation date

1/14/2022 10:03

blood type

test date

1/18/2022

test type

blood test +

evaluation date

1/14/2022

invoice amount

Value Date

1/18/2022

blood type

name

Richy rich

test date

12/21/2021

test type

blood test

evaluation date

12/20/2021

creation date

12/20/2021 09:23

blood type

O-

invoice amount

Value Date

12/21/2021

blood type

O-

and would like to have it

name	creation date	blood type	test date	test type	evaluation date	invoice amount	Value Date
John Doe	1/14/2022 10:03	O	1/18/2022	blood test +	1/14/2022	49	1/18/2022
Richie rich	12/20/2021 09:23	O-	12/21/2021	blood test	12/20/2021	10	12/21/2021