How do I transpose multiple delimited columns
Hi,I'm trying to split and transpose multiple pipe delimited columns and would appreciate some help in finding the most efficient way of doing this.The table contains measurement values at X,Y location for a measurement type.The number of measurements and X,Y locations can vary for each batch and date. Example data and required output shown below. Start tableBatchDateTypeXYValueA101/06/2021L0 | 0 ...
atlas100