transpose column multiple columns

[PTIFANOU]

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

[serpiva64]

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!