Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys
i have csv file and one of the cell (Item Sent) is having multiple values.
How we can extract Item Sent values to separate rows altogether.
Desire output:
RecordID Item Sent
LAB12792 6
LAB12792 100
LAB12792 130
LAB12792 131
LAB12792 132
Any help is greatly appreciated.
Solved! Go to Solution.
Below split operation worked to split above data into separate rows.
FInal Output:
Do you have line breaks in column Item Sent?
the rows are having line feed.
had to try each option one in advanced options to make it work and at last line feed did the magic.
Below split operation worked to split above data into separate rows.
FInal Output:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |