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
- This first one I am working on is the site code but there are many cells where I'm looking to do the same thing for the sample date and same ID, etc. The point of this report is for it to be readable to the average client that might not have a ton of scientific knowledge. I'm not sure I have much wiggle room to change the format our scientist wants.
My experience with arrays of tables and an array of clients is that people respond to clarity, whether it's in rows, columns or separate pages. Even scientists appreciate clarity, and some are capable of changing previous convictions. [insert smiley face here]
- I have a clear report example and am trying to automate. Thank you for the suggestions, but I am going to continue to search for how to do this.