Forum Discussion
Take a range and space it out into columns
I am trying to grab all the values in a range (C2:C224 is the current one, but it will sometimes be a smaller or larger range in the same column) from one sheet and move those to another sheet but I ...
It is for a report that displays scientific data. The spacing is to have a section for each sample.
JennaSmith495 wrote: It is for a report that displays scientific data. The spacing is to have a section for each sample.
Help me understand: are the current cells (C2:C224) labels for the samples, dates, what?
In general, Excel tables work better when each ROW is a complete record unto itself. Most of the Excel functions that summarize, tabulate, etc., are perfectly fitted for series of records arrayed like that, in rows.
https://exceljet.net/excel-tables