Forum Discussion
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 row (the home depot) data comes from another work sheet and gets sorted. I want the remainder of the data in each row to sort with the 1st column info? Suggestions?
6 Replies
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:
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?
