What formula could I use to nest automatically based on primary column?

Savannah S

Hello,

Trying to make it so that information in columns b-f automatically nest under the names in column a instead of doing it manually as I have a large amount of data. For example, John Doe has a badge with two different types of access. I need those to nest under them while John Smith's access information nests under their name if that makes sense? I was thinking it would be some type of IF function but nothing I've tried has worked.

Darren Mullen

@Savannah S Unfortunately, you can't control indenting using a formula.

If you want to group them together for display purposes, you could consider having the cardholder name on each row and then using a report to group by Cardholder name....