Forum Discussion
BillH80
Nov 12, 2021Copper Contributor
combine cells in rows
I have a spreadsheet with 6 columns and unlimited rows. The rows in the first column contain formulas that bring in data from another worksheet. Per below cut: The first column (Project) second ro...
Riny_van_Eekelen
Nov 13, 2021Platinum Contributor
BillH80 Start by deleting empty rows (like the one between the header and the first row with data) and columns in your data (like the two before the due date). Then, you can sort any column of your choice and the other columns will follow. More about sorting in the link below:
- BillH80Nov 15, 2021Copper Contributor
Riny_van_EekelenThanks for the reply but not sure it fixes my problem. I have attached the form I am using that has some notes on it. Maybe this will clarify what I am doing?
- Riny_van_EekelenNov 15, 2021Platinum Contributor
BillH80 Sorry, but pictures aren't very helpful. Difficult to judge how "the other worksheet" influences what you want to achieve.