1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Pull only specific rows and columns from a table

I want to copy certain columns from a table, but only the cells where they cross specific rows. For example, I want to pull columns A,C,F but only where they intersect with rows 2,6,7,and 10. So the new table would have A2,A6,A7,A10,C2,C6, ect. Is there a way to do this without hand-copying or re-typing? I haven't worked much with tables before.

This is for a reference chart I made myself for a game where you place buildings and get (or lose) points based on which buildings are nearby. The rows and columns have the same list of headers: columns are what I want to place, and each row shows how many points each existing building would give. I want to make smaller tables with a few buildings and how they affect each other, such as Harbor, Dock, Lighthouse, and Fisher which all go in the same areas. So I would want to pull just the spots where the columns and rows for those 4 intersect.

submitted by /u/Oday-Dolphin
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#Excel compatibility
#row zero
#cloud-based spreadsheet applications
#table
#columns
#rows
#cells
#reference chart
#building
#points
#intersect
#small tables
#headers
#pull
#Harbor