Power Query table transformation challenge
Hello! I have data that I import form TXT file that looks like this:
Accommodation Apartmán Slezák 2Arrival 05.05.2024 Departure 10.05.2024 First NameNAMELast NameLAST NAMEDate of birth 16.9.1969NationalityCzechReason for visitTourismNumber of additional guests 2StreetStreet 1Postal code111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12345 First NameNAME2Last NameLASTNAME2Date of birth 26.3.1999NationalityCzechStreetStreet 2Postal code1111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12346 First NameNAME3Last NameLASTNAME3Date of birth 24.1.2023NationalityCzechStreetStreet 2Postal code1111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12346
And I would like it to look like this:
AccommodationArrivalDepartureFirst NameLast NameDate of birthNationalityReason for visitStreetPostal codeCityCountryDocument TypeDocument number Apartmán Slezák 2 05.05.2024 10.05.2024 NAMELAST NAME 16.9.1969CzechTourismStreet 1111111PragueCzechia ID / License12345 Apartmán Slezák 2 05.05.2024 10.05.2024 NAME2LASTNAME2 26.3.1999CzechTourismStreet 21111111PragueCzechia ID / License12346 Apartmán Slezák 2 05.05.2024 10.05.2024 NAME3LASTNAME3 24.1.2023CzechTourismStreet 21111111PragueCzechia ID / License12346
I have used group by but I am unable to expand the tables into rows. Could sb. please help me? Thanks!
Hello! I have data that I import form TXT file that looks like this: Accommodation Apartmán Slezák 2Arrival 05.05.2024 Departure 10.05.2024 First NameNAMELast NameLAST NAMEDate of birth 16.9.1969NationalityCzechReason for visitTourismNumber of additional guests 2StreetStreet 1Postal code111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12345 First NameNAME2Last NameLASTNAME2Date of birth 26.3.1999NationalityCzechStreetStreet 2Postal code1111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12346 First NameNAME3Last NameLASTNAME3Date of birth 24.1.2023NationalityCzechStreetStreet 2Postal code1111111CityPragueCountryCzechiaDocument Type ID / LicenseDocument number12346 And I would like it to look like this: AccommodationArrivalDepartureFirst NameLast NameDate of birthNationalityReason for visitStreetPostal codeCityCountryDocument TypeDocument number Apartmán Slezák 2 05.05.2024 10.05.2024 NAMELAST NAME 16.9.1969CzechTourismStreet 1111111PragueCzechia ID / License12345 Apartmán Slezák 2 05.05.2024 10.05.2024 NAME2LASTNAME2 26.3.1999CzechTourismStreet 21111111PragueCzechia ID / License12346 Apartmán Slezák 2 05.05.2024 10.05.2024 NAME3LASTNAME3 24.1.2023CzechTourismStreet 21111111PragueCzechia ID / License12346 I have used group by but I am unable to expand the tables into rows. Could sb. please help me? Thanks! Read More