Hello,
Being a close-to-novice Excel user, I have come across a problem (or a challenge rather) involving huge sets of data which need to be transposed from rows into columns.
please see attached workbook. In the "Raw Data" worksheet, you will notice the first two columns being the date and the time that the data was logged. Data was logged every 10 seconds (roughly) for about 491 parameters (see Column C). After every 491 parameters the time changes and continues on for another 491 rows. What I require is:
1. Only the "tag indices" from 346 to 408 in Column C and the corresponding "Value" in Column D for every time interval.
2. The above parameters which are currently being tabulated row-wise to be transposed column-wise. See worksheet "Required" where I have shown a sample of how I want the data to be organized.
3. NOTE: As this data was logged by a data logger, the data is not consistent. Some time intervals (not in this workbook but in others) just stop at "200 tag indices" and jump to the next time interval. Hence the data sorting and transposing is probably best achieved by looking at the "time" rather than the "tag index". In such cases, the values would be ZERO for the tag indices that I am after.
If there is a quick and easy (being rather hopeful!!) way to do this by a macro or some such thing, it would be great as I have about a 100 such workbooks that I need to sort!!! Help highly appreciated with loads of thanks in advance.
If something is unclear, please let me know.
Sincerely,
Ananth
Bookmarks