Adding tabs/leader to multiple rows in one column

You can use a GREP find and replace to add a tab into each cell. Select the column, and use this

Find:   .$

Change to:  $0\t

This will add the tab. If you set up your paragraph style with the tab settng and leader, you can include the paragraph style in the replace, and fix it all at once.

I think I see your problem.

In the screen capture you supplied, the Tabs Ruler doesn't extend all the way across the text. Drag the lower-right corner of the ruler to the right and you'll be able to see tabs all the way across the text. The right-align tab won't align to absolutely nothing. I'll bet you a nickel if you put a space in at the tab, your dot leader will appear. Another option would be to apply that dot leader to the next tab, your center-align tab for the parts numbers, and the dots will go all the way to the edge of your part numbers.

For what it's worth, I don't know this because I'm Rhodes Scholar-bright; I know this because I've messed up that way before.

Tabbed leaders can be part of a Paragraph Style. So set the tabbed line with the leader and save it as a Paragraph Style and then apply the style as needed:

Randy thank you - I do have them set however they dont "appear" I have to hit Control Tab (I am on a PC) to insert the tab with the leader in each row (which may be the case was just hoping there was an auto way to insert them all at once) .Also to be clear the imported info has four columns - so I was inaccurate in saying the middle column that is actually the second column, so I am just trying to get leader tabs at the end of every row in the second column only.... not sure if that will make a difference. 

Sure.

1. Highlight all the text, then select the Type>Tabs menu command (Cmd/Ctrl+Shift+T keyboard shortcut, depending on whether you're on a Mac/Windows system, respectively).
2. Place your tabs, per your example right-align for the second column and centered for the third.
3. Click on the second, right-aligned tab. Put a period in the Leader: edit box and admire your handiwork. You should see dot leaders leading to the second tab for every row you highlighted.

Hope this helps,

Randy