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-nu...
I basically have this data
| data_header |
| name |
| John Doe |
| creation date |
| 1/14/2022 10:03 |
| blood type |
| O |
| test date |
| 1/18/2022 |
| test type |
| blood test + |
| evaluation date |
| 1/14/2022 |
| invoice amount |
| 49 |
| Value Date |
| 1/18/2022 |
| blood type |
| O |
| name |
| Richy rich |
| test date |
| 12/21/2021 |
| test type |
| blood test |
| evaluation date |
| 12/20/2021 |
| creation date |
|
| blood type |
| O- |
| invoice amount |
| 10 |
| 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 |
