Hi Everyone,
New member here, thanks for letting me join, lots of great into although I cant seem to find what I'm looking for. Please go a little easy as I'm fairly new to VBA. I have what I believe is a 'not' so easy transpose of data from a Vertical format to a "sorted" Horizontal format that is dependent on the number of elements present in the raw data file.
The data I have attached is from an instrument that does not allow data to be exported in a horizontal format. It is a small example of what can be a larger export file with more line items, i.e. the number of rows can change from export to export. The raw data as it is exported from the instrument is shown in Columns A to D. The required output is shown in columns P to S (although it does not need to be specifically there, with the ultimate aim to create a new workbook with the transposed/sorted data). I hope this makes some sense. Thank you for any help you may be able to offer.
New member here, thanks for letting me join, lots of great into although I cant seem to find what I'm looking for. Please go a little easy as I'm fairly new to VBA. I have what I believe is a 'not' so easy transpose of data from a Vertical format to a "sorted" Horizontal format that is dependent on the number of elements present in the raw data file.
The data I have attached is from an instrument that does not allow data to be exported in a horizontal format. It is a small example of what can be a larger export file with more line items, i.e. the number of rows can change from export to export. The raw data as it is exported from the instrument is shown in Columns A to D. The required output is shown in columns P to S (although it does not need to be specifically there, with the ultimate aim to create a new workbook with the transposed/sorted data). I hope this makes some sense. Thank you for any help you may be able to offer.