I have a spreadsheet that reports on database errors. Unfortunately, it arranges the errors in two columns, A is Labels and B is the data for the labels. Normally I just use Copy & Transpose Paste and do it manually, but due to a major incident, this report is currently several thousand lines. I tried using Offset and even Offset(Row) formulas, but either I'm doing something wrong, or I need another method. I attached a sample sheet with just a couple of errors and the errors transposed manually to show what I need, as well as examples of the two formulas I tried. Anybody have any ideas?
Bookmarks