So I have this data in multiple files in a folder. The data is formated in the following way:
First column: Date and time
Second column: Measured value of series 1
Third column: Status of measured value series 1
Forth column: Measure value of series 2
Fifth column: Status value of series 2
The amount of columns is dependent on how many series is in that file. I would like to make a function to clean and make the data neat for all the files in the folder. I do this by merging the column Measured value and Status and then splitting it and normalizing it. But since the data has different amount of columns cross the files I'm having a hard time creating a function for this. Anybody have any good suggestions to create a function to merge every other column except the first one, independent on number of columns?
But an alternative could be using functions like Table.ColumnNames or Record.FieldNames. You get a list of all columns of a table or a record which you can filter with List.Select. And then you can do your magic. It expects more programming skills in M.