Forum Discussion
transpose column multiple columns
Hi every one?
i'am a beginner on powerbi, i would like to transform a dataset formy work and i can't figure it out
here's what my data looks like:
| file id 1 | file id 2 | file id 3 | file id 4 | file id 5 | creation date file1 | creation date file2 | creation date file3 | creation date file4 | creation date file5 |
| 15010 | 15011 | 15012 | 18/01/23 | 24/05/22 | 21/08/22 | ||||
| 17518 | 22/02/22 | ||||||||
| 18456 | 18457 | 18458 | 14/03/22 | 17/05/22 | 18/06/22 | ||||
| 21458 | 21459 | 21460 | 21461 | 21462 | 07/01/22 | 12/02/22 | 14/04/22 | 19/09/22 | 21/11/22 |
And what i want to do
| file id | creation date |
| 15010 | 18/01/23 |
| 17518 | 22/02/22 |
| 18456 | 14/03/22 |
| 21458 | 07/01/22 |
| 15011 | 24/05/22 |
| 18457 | 17/05/22 |
| 21459 | 12/02/22 |
| 15012 | 21/08/22 |
| 18458 | 18/06/22 |
| 21460 | 14/04/22 |
| 21461 | 19/09/22 |
| 21462 | 21/11/22 |
if someone can help me
thanks
1 Reply
Hi,
You obtain this
by applying the steps of the attached file
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
