Need to display list of array as single array in python

You are always reassigning row which is not what you want. That's why you can't save the last value. The append() function is what you want. Here's an example:

rows = []
loc = 'output.xlsx'
wb = xlrd.open_workbook(loc) 
sheet = wb.sheet_by_index(0)
for i in range(1,sheet.nrows):
    row = sheet.row_values(i)
    if row[0] == "A":
        rows.append(row)
print(rows)

You could save the row in an array. result = [] result.append(row) and then print result, like is explained here Python appending array to an array

You can do it simply by creating another array, and appending the desired arrays on the go

array_to_print = []
row =[]
loc = 'output.xlsx'
wb = xlrd.open_workbook(loc) 
sheet = wb.sheet_by_index(0)
for i in range(1,sheet.nrows):
    row = sheet.row_values(i)
    if row[0] == "A":
        array_to_print.append(row)       
    else:
        #print(row)  #not understood what you meant to do with it
print(array_to_print)

Do you intend to be using the "row" variable twice? You're printing row in your if statement and in the else statement, but I don't think printing is your ultimate goal here. Up top you declare an empty list:

row = []

But later you change that variable to:

row = sheet.row_values(i)

In pythonm, you don't need to declare row as a list at the top, but... if you changed your empty list declaration to something else, like "output_row" you could use it to store your rows:

output_rows = []
loc = 'output.xlsx'
wb = xlrd.open_workbook(loc) 
sheet = wb.sheet_by_index(0)
for i in range(1,sheet.nrows):
  row = sheet.row_values(i)
  if row[0] == "A":
    output_rows.append(row)       
  else:
    print(row) # or whatever
print(output_rows)