SOLVED
Transposing rows to columns when all the data is in one column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Nevi1211
7 - Meteor
‎01-20-2022
03:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
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 |
12/20/2021 09:23 |
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
|
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
3 REPLIES 3
atcodedog05
22 - Nova
‎01-20-2022
03:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
atcodedog05
22 - Nova
‎01-20-2022
04:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @Nevi1211
Cheers and have a nice day!
‎01-20-2022
04:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ atcodedog05 ,
thank you so much it works perfectly, the bit that I was missing was the multirow formula.
This community is awesome, thanks again for the quick response !
Nevi