Hi all,
Seeking help to convert date column to date row.
example:
From
Date |
02-May-24 |
09-Oct-23 |
27-May-24 |
08-Feb-24 |
06-May-24 |
20-May-24 |
30-Oct-23 |
20-Feb-24 |
01-Oct-23 |
To
Date | 02-May-24 | 09-Oct-23 | 27-May-24 | 08-Feb-24 | 06-May-24 | 20-May-24 | 30-Oct-23 | 20-Feb-24 | 01-Oct-23 |
You could use the cross tab tool but it will depend on what other columns you have and what you need to do with the data?
@shahnawaz_khan add a record id tool to your text input and cross tab