Grouping Rows together

How do I create sub rows that would fall underneath a given row in a spreadsheet, yet would remain attached to each other? So if my Column A is titled Agency, and I have Acme listed under it with all it's contact info in columns B and on, but need to connect "Acme: North" and "Acme: South" and all of their information in separate rows, but want them to always be together under "Acme" - how do I do that?

Thanks!

Hi and welcome to the forum.

Not quite sure what you mean by 'create sub rows', and 'remain attached to each other', but I suggest it would be better if you populated the whole of column A with the relevant Agency reference then you could use Excel's standard autofilter functionality.

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"