1.
if i have a sheet where some of it has data from a diff sheet using a formula
how can i actually copy the whole table with data only and not the formula
so i wont need to rely on the other sheets.

2. if i have 2 column2 lets say Address1 address2 how can i merge those 2 on
every row? it is important that when it merges it will place a space between
the merged data so it one be one word.

Thank you!!!